Dataset Report

Dataset statistics

Number of variables	22
Number of observations	940
Missing cells	6580
Missing cells (%)	31.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	201.2 KiB
Average record size in memory	219.2 B

Variable types

Numeric	14
Categorical	1
Unsupported	7

Alerts

`TotalSteps` is highly overall correlated with `TotalDistance` and 8 other fields	High correlation
`TotalDistance` is highly overall correlated with `TotalSteps` and 8 other fields	High correlation
`TrackerDistance` is highly overall correlated with `TotalSteps` and 8 other fields	High correlation
`VeryActiveDistance` is highly overall correlated with `TotalSteps` and 5 other fields	High correlation
`ModeratelyActiveDistance` is highly overall correlated with `TotalSteps` and 5 other fields	High correlation
`LightActiveDistance` is highly overall correlated with `TotalSteps` and 3 other fields	High correlation
`VeryActiveMinutes` is highly overall correlated with `TotalSteps` and 6 other fields	High correlation
`FairlyActiveMinutes` is highly overall correlated with `TotalSteps` and 5 other fields	High correlation
`LightlyActiveMinutes` is highly overall correlated with `TotalSteps` and 3 other fields	High correlation
`Calories` is highly overall correlated with `TotalSteps` and 3 other fields	High correlation
`Date` has 940 (100.0%) missing values	Missing
`WeightKg` has 940 (100.0%) missing values	Missing
`WeightPounds` has 940 (100.0%) missing values	Missing
`Fat` has 940 (100.0%) missing values	Missing
`BMI` has 940 (100.0%) missing values	Missing
`IsManualReport` has 940 (100.0%) missing values	Missing
`LogId` has 940 (100.0%) missing values	Missing
`ActivityDate` is uniformly distributed	Uniform
`Date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`WeightKg` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`WeightPounds` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Fat` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`BMI` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`IsManualReport` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`LogId` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`TotalSteps` has 77 (8.2%) zeros	Zeros
`TotalDistance` has 78 (8.3%) zeros	Zeros
`TrackerDistance` has 78 (8.3%) zeros	Zeros
`LoggedActivitiesDistance` has 908 (96.6%) zeros	Zeros
`VeryActiveDistance` has 413 (43.9%) zeros	Zeros
`ModeratelyActiveDistance` has 386 (41.1%) zeros	Zeros
`LightActiveDistance` has 85 (9.0%) zeros	Zeros
`SedentaryActiveDistance` has 858 (91.3%) zeros	Zeros
`VeryActiveMinutes` has 409 (43.5%) zeros	Zeros
`FairlyActiveMinutes` has 384 (40.9%) zeros	Zeros
`LightlyActiveMinutes` has 84 (8.9%) zeros	Zeros

Reproduction

Analysis started	2023-01-21 22:25:00.321395
Analysis finished	2023-01-21 22:25:14.983704
Duration	14.66 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

Id
Real number (ℝ)

Distinct	33
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8554074 × 10⁹

Minimum	1.5039604 × 10⁹
Maximum	8.8776894 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	1.5039604 × 10⁹
5-th percentile	1.6245801 × 10⁹
Q1	2.320127 × 10⁹
median	4.445115 × 10⁹
Q3	6.9621811 × 10⁹
95-th percentile	8.7920097 × 10⁹
Maximum	8.8776894 × 10⁹
Range	7.373729 × 10⁹
Interquartile range (IQR)	4.6420541 × 10⁹

Descriptive statistics

Standard deviation	2.4248055 × 10⁹
Coefficient of variation (CV)	0.4994031
Kurtosis	-1.2730307
Mean	4.8554074 × 10⁹
Median Absolute Deviation (MAD)	2.418763 × 10⁹
Skewness	0.1771249
Sum	4.5640829 × 10¹²
Variance	5.8796816 × 10¹⁸
Monotonicity	Increasing

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
1503960366	31	3.3%
4319703577	31	3.3%
8583815059	31	3.3%
8378563200	31	3.3%
8053475328	31	3.3%
7086361926	31	3.3%
6962181067	31	3.3%
5553957443	31	3.3%
4702921684	31	3.3%
4558609924	31	3.3%
Other values (23)	630	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1503960366	31	3.3%
1624580081	31	3.3%
1644430081	30	3.2%
1844505072	31	3.3%
1927972279	31	3.3%
2022484408	31	3.3%
2026352035	31	3.3%
2320127002	31	3.3%
2347167796	18	1.9%
2873212765	31	3.3%

Value	Count	Frequency (%)
8877689391	31	3.3%
8792009665	29	3.1%
8583815059	31	3.3%
8378563200	31	3.3%
8253242879	19	2.0%
8053475328	31	3.3%
7086361926	31	3.3%
7007744171	26	2.8%
6962181067	31	3.3%
6775888955	26	2.8%

ActivityDate
Categorical

Distinct	31
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Memory size	14.7 KiB

4/12/2016	33
4/14/2016	33
4/15/2016	33
4/13/2016	33
4/23/2016	32
Other values (26)	776

Length

Max length	9
Median length	9
Mean length	8.7255319
Min length	8

Characters and Unicode

Total characters	8202
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4/12/2016
2nd row	4/13/2016
3rd row	4/14/2016
4th row	4/15/2016
5th row	4/16/2016

Common Values

Value	Count	Frequency (%)
4/12/2016	33	3.5%
4/14/2016	33	3.5%
4/15/2016	33	3.5%
4/13/2016	33	3.5%
4/23/2016	32	3.4%
4/29/2016	32	3.4%
4/28/2016	32	3.4%
4/26/2016	32	3.4%
4/25/2016	32	3.4%
4/24/2016	32	3.4%
Other values (21)	616	65.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4/12/2016	33	3.5%
4/15/2016	33	3.5%
4/13/2016	33	3.5%
4/14/2016	33	3.5%
4/22/2016	32	3.4%
4/21/2016	32	3.4%
4/16/2016	32	3.4%
4/18/2016	32	3.4%
4/19/2016	32	3.4%
4/20/2016	32	3.4%
Other values (21)	616	65.5%

Most occurring characters

Value	Count	Frequency (%)
/	1880	22.9%
2	1375	16.8%
1	1357	16.5%
6	1033	12.6%
0	1029	12.5%
4	705	8.6%
5	423	5.2%
3	125	1.5%
7	93	1.1%
9	91	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6322	77.1%
Other Punctuation	1880	22.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1375	21.7%
1	1357	21.5%
6	1033	16.3%
0	1029	16.3%
4	705	11.2%
5	423	6.7%
3	125	2.0%
7	93	1.5%
9	91	1.4%
8	91	1.4%

Other Punctuation

Value	Count	Frequency (%)
/	1880	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8202	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
/	1880	22.9%
2	1375	16.8%
1	1357	16.5%
6	1033	12.6%
0	1029	12.5%
4	705	8.6%
5	423	5.2%
3	125	1.5%
7	93	1.1%
9	91	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8202	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	1880	22.9%
2	1375	16.8%
1	1357	16.5%
6	1033	12.6%
0	1029	12.5%
4	705	8.6%
5	423	5.2%
3	125	1.5%
7	93	1.1%
9	91	1.1%

TotalSteps
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	842
Distinct (%)	89.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7637.9106

Minimum	0
Maximum	36019
Zeros	77
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3789.75
median	7405.5
Q3	10727
95-th percentile	15485.1
Maximum	36019
Range	36019
Interquartile range (IQR)	6937.25

Descriptive statistics

Standard deviation	5087.1507
Coefficient of variation (CV)	0.66603957
Kurtosis	1.1691112
Mean	7637.9106
Median Absolute Deviation (MAD)	3446.5
Skewness	0.65289494
Sum	7179636
Variance	25879103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	77	8.2%
244	2	0.2%
6708	2	0.2%
9167	2	0.2%
6175	2	0.2%
10538	2	0.2%
1510	2	0.2%
8538	2	0.2%
7937	2	0.2%
4363	2	0.2%
Other values (832)	845	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	77	8.2%
4	1	0.1%
8	1	0.1%
9	1	0.1%
16	1	0.1%
17	1	0.1%
29	1	0.1%
31	1	0.1%
42	1	0.1%
44	1	0.1%

Value	Count	Frequency (%)
36019	1	0.1%
29326	1	0.1%
27745	1	0.1%
23629	1	0.1%
23186	1	0.1%
22988	1	0.1%
22770	1	0.1%
22359	1	0.1%
22244	1	0.1%
22026	1	0.1%

TotalDistance
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	615
Distinct (%)	65.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4897021

Minimum	0
Maximum	28.030001
Zeros	78
Zeros (%)	8.3%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.6199999
median	5.2449999
Q3	7.7125
95-th percentile	11.6565
Maximum	28.030001
Range	28.030001
Interquartile range (IQR)	5.0925001

Descriptive statistics

Standard deviation	3.9246059
Coefficient of variation (CV)	0.71490325
Kurtosis	3.1130184
Mean	5.4897021
Median Absolute Deviation (MAD)	2.5600001
Skewness	1.1262736
Sum	5160.32
Variance	15.402532
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	78	8.3%
2.599999905	5	0.5%
0.009999999776	5	0.5%
3.910000086	4	0.4%
4.949999809	4	0.4%
1.789999962	4	0.4%
4.329999924	4	0.4%
2.680000067	4	0.4%
3.50999999	4	0.4%
4.900000095	4	0.4%
Other values (605)	824	87.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	78	8.3%
0.009999999776	5	0.5%
0.01999999955	1	0.1%
0.02999999933	2	0.2%
0.03999999911	1	0.1%
0.07999999821	1	0.1%
0.09000000358	1	0.1%
0.1000000015	1	0.1%
0.1099999994	1	0.1%
0.1299999952	1	0.1%

Value	Count	Frequency (%)
28.03000069	1	0.1%
26.71999931	1	0.1%
25.29000092	1	0.1%
20.64999962	1	0.1%
20.39999962	1	0.1%
19.55999947	1	0.1%
19.34000015	1	0.1%
18.97999954	1	0.1%
18.25	1	0.1%
18.11000061	1	0.1%

TrackerDistance
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	613
Distinct (%)	65.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4753511

Minimum	0
Maximum	28.030001
Zeros	78
Zeros (%)	8.3%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.6199999
median	5.2449999
Q3	7.71
95-th percentile	11.6565
Maximum	28.030001
Range	28.030001
Interquartile range (IQR)	5.0900002

Descriptive statistics

Standard deviation	3.9072759
Coefficient of variation (CV)	0.71361195
Kurtosis	3.2038891
Mean	5.4753511
Median Absolute Deviation (MAD)	2.5550003
Skewness	1.1345496
Sum	5146.83
Variance	15.266805
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	78	8.3%
2.599999905	5	0.5%
0.009999999776	5	0.5%
3.910000086	4	0.4%
2.680000067	4	0.4%
1.789999962	4	0.4%
4.329999924	4	0.4%
4.949999809	4	0.4%
3.50999999	4	0.4%
8.739999771	4	0.4%
Other values (603)	824	87.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	78	8.3%
0.009999999776	5	0.5%
0.01999999955	1	0.1%
0.02999999933	2	0.2%
0.03999999911	1	0.1%
0.07999999821	1	0.1%
0.09000000358	1	0.1%
0.1000000015	1	0.1%
0.1099999994	1	0.1%
0.1299999952	1	0.1%

Value	Count	Frequency (%)
28.03000069	1	0.1%
26.71999931	1	0.1%
25.29000092	1	0.1%
20.64999962	1	0.1%
20.39999962	1	0.1%
19.55999947	1	0.1%
19.34000015	1	0.1%
18.97999954	1	0.1%
18.25	1	0.1%
18.11000061	1	0.1%

LoggedActivitiesDistance
Real number (ℝ)

Distinct	19
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10817094

Minimum	0
Maximum	4.942142
Zeros	908
Zeros (%)	96.6%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	4.942142
Range	4.942142
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.61989652
Coefficient of variation (CV)	5.7307121
Kurtosis	41.295941
Mean	0.10817094
Median Absolute Deviation (MAD)	0
Skewness	6.2974404
Sum	101.68068
Variance	0.38427169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	908	96.6%
2.092147112	9	1.0%
2.253081083	7	0.7%
4.081692219	1	0.1%
4.861792088	1	0.1%
4.878232002	1	0.1%
4.912367821	1	0.1%
2.832325935	1	0.1%
4.911146164	1	0.1%
4.885604858	1	0.1%
Other values (9)	9	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	908	96.6%
1.959596038	1	0.1%
2.092147112	9	1.0%
2.253081083	7	0.7%
2.785175085	1	0.1%
2.832325935	1	0.1%
3.167821884	1	0.1%
3.285414934	1	0.1%
4.081692219	1	0.1%
4.851306915	1	0.1%

Value	Count	Frequency (%)
4.94214201	1	0.1%
4.930550098	1	0.1%
4.924840927	1	0.1%
4.912367821	1	0.1%
4.911146164	1	0.1%
4.885604858	1	0.1%
4.878232002	1	0.1%
4.869782925	1	0.1%
4.861792088	1	0.1%
4.851306915	1	0.1%

VeryActiveDistance
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	333
Distinct (%)	35.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5026809

Minimum	0
Maximum	21.92
Zeros	413
Zeros (%)	43.9%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.20999999
Q3	2.0524999
95-th percentile	6.4030001
Maximum	21.92
Range	21.92
Interquartile range (IQR)	2.0524999

Descriptive statistics

Standard deviation	2.6589412
Coefficient of variation (CV)	1.769465
Kurtosis	11.910951
Mean	1.5026809
Median Absolute Deviation (MAD)	0.20999999
Skewness	2.99617
Sum	1412.52
Variance	7.0699681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	413	43.9%
0.0700000003	9	1.0%
0.05999999866	6	0.6%
0.1400000006	5	0.5%
0.3300000131	5	0.5%
0.3400000036	4	0.4%
1.059999943	4	0.4%
0.3600000143	4	0.4%
1.00999999	4	0.4%
2.789999962	4	0.4%
Other values (323)	482	51.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	413	43.9%
0.01999999955	2	0.2%
0.03999999911	1	0.1%
0.05000000075	3	0.3%
0.05999999866	6	0.6%
0.0700000003	9	1.0%
0.07999999821	4	0.4%
0.09000000358	1	0.1%
0.1099999994	3	0.3%
0.1199999973	3	0.3%

Value	Count	Frequency (%)
21.92000008	1	0.1%
21.65999985	1	0.1%
13.39999962	1	0.1%
13.26000023	1	0.1%
13.23999977	1	0.1%
13.22000027	1	0.1%
13.13000011	1	0.1%
13.06999969	1	0.1%
12.78999996	1	0.1%
12.53999996	1	0.1%

ModeratelyActiveDistance
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	211
Distinct (%)	22.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.56754255

Minimum	0
Maximum	6.48
Zeros	386
Zeros (%)	41.1%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.23999999
Q3	0.80000001
95-th percentile	2.1300001
Maximum	6.48
Range	6.48
Interquartile range (IQR)	0.80000001

Descriptive statistics

Standard deviation	0.88358032
Coefficient of variation (CV)	1.556853
Kurtosis	10.125629
Mean	0.56754255
Median Absolute Deviation (MAD)	0.23999999
Skewness	2.7711936
Sum	533.49
Variance	0.78071418
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	386	41.1%
0.200000003	9	1.0%
0.2800000012	9	1.0%
0.400000006	9	1.0%
0.25	8	0.9%
0.3100000024	8	0.9%
0.9300000072	8	0.9%
0.4199999869	8	0.9%
0.2700000107	7	0.7%
0.5699999928	7	0.7%
Other values (201)	481	51.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	386	41.1%
0.009999999776	1	0.1%
0.01999999955	1	0.1%
0.02999999933	3	0.3%
0.03999999911	3	0.3%
0.05000000075	3	0.3%
0.05999999866	3	0.3%
0.0700000003	2	0.2%
0.07999999821	4	0.4%
0.09000000358	2	0.2%

Value	Count	Frequency (%)
6.480000019	1	0.1%
6.210000038	1	0.1%
5.599999905	1	0.1%
5.400000095	1	0.1%
5.239999771	1	0.1%
5.119999886	1	0.1%
4.579999924	1	0.1%
4.559999943	1	0.1%
4.349999905	1	0.1%
4.21999979	3	0.3%

LightActiveDistance
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	491
Distinct (%)	52.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3408191

Minimum	0
Maximum	10.71
Zeros	85
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.945
median	3.3649999
Q3	4.7825001
95-th percentile	6.462
Maximum	10.71
Range	10.71
Interquartile range (IQR)	2.8375001

Descriptive statistics

Standard deviation	2.0406554
Coefficient of variation (CV)	0.61082486
Kurtosis	-0.18030027
Mean	3.3408191
Median Absolute Deviation (MAD)	1.4200002
Skewness	0.18224747
Sum	3140.37
Variance	4.1642744
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	85	9.0%
4.179999828	6	0.6%
3.170000076	6	0.6%
4.880000114	6	0.6%
3.230000019	6	0.6%
3.940000057	5	0.5%
3.25999999	5	0.5%
0.009999999776	5	0.5%
4.460000038	5	0.5%
5.409999847	5	0.5%
Other values (481)	806	85.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	85	9.0%
0.009999999776	5	0.5%
0.01999999955	1	0.1%
0.02999999933	3	0.3%
0.03999999911	1	0.1%
0.05999999866	1	0.1%
0.09000000358	1	0.1%
0.1000000015	1	0.1%
0.1099999994	1	0.1%
0.1299999952	2	0.2%

Value	Count	Frequency (%)
10.71000004	1	0.1%
10.56999969	1	0.1%
10.30000019	1	0.1%
9.479999542	1	0.1%
9.460000038	1	0.1%
8.970000267	1	0.1%
8.789999962	1	0.1%
8.680000305	1	0.1%
8.409999847	1	0.1%
8.270000458	1	0.1%

SedentaryActiveDistance
Real number (ℝ)

Distinct	9
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.001606383

Minimum	0
Maximum	0.11
Zeros	858
Zeros (%)	91.3%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.0099999998
Maximum	0.11
Range	0.11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0073461763
Coefficient of variation (CV)	4.5731164
Kurtosis	99.127446
Mean	0.001606383
Median Absolute Deviation (MAD)	0
Skewness	8.5898992
Sum	1.51
Variance	5.3966306 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	858	91.3%
0.009999999776	50	5.3%
0.01999999955	21	2.2%
0.02999999933	4	0.4%
0.05000000075	3	0.3%
0.0700000003	1	0.1%
0.03999999911	1	0.1%
0.1099999994	1	0.1%
0.1000000015	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	858	91.3%
0.009999999776	50	5.3%
0.01999999955	21	2.2%
0.02999999933	4	0.4%
0.03999999911	1	0.1%
0.05000000075	3	0.3%
0.0700000003	1	0.1%
0.1000000015	1	0.1%
0.1099999994	1	0.1%

Value	Count	Frequency (%)
0.1099999994	1	0.1%
0.1000000015	1	0.1%
0.0700000003	1	0.1%
0.05000000075	3	0.3%
0.03999999911	1	0.1%
0.02999999933	4	0.4%
0.01999999955	21	2.2%
0.009999999776	50	5.3%
0	858	91.3%

VeryActiveMinutes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	122
Distinct (%)	13.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.164894

Minimum	0
Maximum	210
Zeros	409
Zeros (%)	43.5%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	32
95-th percentile	93.05
Maximum	210
Range	210
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	32.844803
Coefficient of variation (CV)	1.551853
Kurtosis	5.7780701
Mean	21.164894
Median Absolute Deviation (MAD)	4
Skewness	2.1761432
Sum	19895
Variance	1078.7811
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	409	43.5%
1	23	2.4%
2	18	1.9%
3	16	1.7%
8	15	1.6%
6	14	1.5%
11	14	1.5%
19	13	1.4%
5	13	1.4%
14	12	1.3%
Other values (112)	393	41.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	409	43.5%
1	23	2.4%
2	18	1.9%
3	16	1.7%
4	10	1.1%
5	13	1.4%
6	14	1.5%
7	11	1.2%
8	15	1.6%
9	7	0.7%

Value	Count	Frequency (%)
210	1	0.1%
207	1	0.1%
200	1	0.1%
194	1	0.1%
186	1	0.1%
184	1	0.1%
137	1	0.1%
132	1	0.1%
129	1	0.1%
125	2	0.2%

FairlyActiveMinutes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	81
Distinct (%)	8.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.564894

Minimum	0
Maximum	143
Zeros	384
Zeros (%)	40.9%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	6
Q3	19
95-th percentile	51
Maximum	143
Range	143
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	19.987404
Coefficient of variation (CV)	1.4734656
Kurtosis	7.9957314
Mean	13.564894
Median Absolute Deviation (MAD)	6
Skewness	2.479492
Sum	12751
Variance	399.49632
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	384	40.9%
8	36	3.8%
6	23	2.4%
5	23	2.4%
16	22	2.3%
7	20	2.1%
10	19	2.0%
9	19	2.0%
13	18	1.9%
11	18	1.9%
Other values (71)	358	38.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	384	40.9%
1	10	1.1%
2	8	0.9%
3	9	1.0%
4	14	1.5%
5	23	2.4%
6	23	2.4%
7	20	2.1%
8	36	3.8%
9	19	2.0%

Value	Count	Frequency (%)
143	1	0.1%
125	1	0.1%
122	1	0.1%
116	1	0.1%
115	1	0.1%
113	1	0.1%
98	1	0.1%
96	1	0.1%
95	5	0.5%
94	1	0.1%

LightlyActiveMinutes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	335
Distinct (%)	35.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	192.81277

Minimum	0
Maximum	518
Zeros	84
Zeros (%)	8.9%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	127
median	199
Q3	264
95-th percentile	369.05
Maximum	518
Range	518
Interquartile range (IQR)	137

Descriptive statistics

Standard deviation	109.1747
Coefficient of variation (CV)	0.56622132
Kurtosis	-0.36011793
Mean	192.81277
Median Absolute Deviation (MAD)	69
Skewness	-0.037929343
Sum	181244
Variance	11919.115
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	84	8.9%
206	12	1.3%
258	10	1.1%
195	9	1.0%
214	8	0.9%
139	7	0.7%
238	7	0.7%
141	7	0.7%
199	7	0.7%
227	7	0.7%
Other values (325)	782	83.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	84	8.9%
1	3	0.3%
2	4	0.4%
3	3	0.3%
4	1	0.1%
9	3	0.3%
10	2	0.2%
11	1	0.1%
12	2	0.2%
15	1	0.1%

Value	Count	Frequency (%)
518	1	0.1%
513	1	0.1%
512	1	0.1%
487	1	0.1%
480	1	0.1%
475	1	0.1%
461	1	0.1%
458	1	0.1%
448	1	0.1%
439	1	0.1%

SedentaryMinutes
Real number (ℝ)

Distinct	549
Distinct (%)	58.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	991.21064

Minimum	0
Maximum	1440
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	536.7
Q1	729.75
median	1057.5
Q3	1229.5
95-th percentile	1440
Maximum	1440
Range	1440
Interquartile range (IQR)	499.75

Descriptive statistics

Standard deviation	301.26744
Coefficient of variation (CV)	0.30393887
Kurtosis	-0.66595003
Mean	991.21064
Median Absolute Deviation (MAD)	261
Skewness	-0.29449809
Sum	931738
Variance	90762.068
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1440	79	8.4%
1182	7	0.7%
692	6	0.6%
1112	5	0.5%
1131	5	0.5%
1122	5	0.5%
1105	5	0.5%
709	5	0.5%
1119	5	0.5%
728	5	0.5%
Other values (539)	813	86.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
2	1	0.1%
13	1	0.1%
48	1	0.1%
111	1	0.1%
125	1	0.1%
127	1	0.1%
218	1	0.1%
222	1	0.1%
241	1	0.1%

Value	Count	Frequency (%)
1440	79	8.4%
1439	3	0.3%
1438	3	0.3%
1437	2	0.2%
1431	1	0.1%
1430	2	0.2%
1428	1	0.1%
1423	1	0.1%
1420	1	0.1%
1413	1	0.1%

Calories
Real number (ℝ)

Distinct	734
Distinct (%)	78.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2303.6096

Minimum	0
Maximum	4900
Zeros	4
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	14.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1372.85
Q1	1828.5
median	2134
Q3	2793.25
95-th percentile	3654.25
Maximum	4900
Range	4900
Interquartile range (IQR)	964.75

Descriptive statistics

Standard deviation	718.16686
Coefficient of variation (CV)	0.3117572
Kurtosis	0.62502694
Mean	2303.6096
Median Absolute Deviation (MAD)	467
Skewness	0.42245048
Sum	2165393
Variance	515763.64
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1980	13	1.4%
2063	11	1.2%
1841	9	1.0%
1688	9	1.0%
1347	8	0.9%
2225	4	0.4%
1819	4	0.4%
2044	4	0.4%
1922	4	0.4%
0	4	0.4%
Other values (724)	870	92.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	0.4%
52	1	0.1%
57	1	0.1%
120	1	0.1%
257	1	0.1%
403	1	0.1%
665	1	0.1%
741	1	0.1%
928	1	0.1%
1002	1	0.1%

Value	Count	Frequency (%)
4900	1	0.1%
4552	1	0.1%
4547	1	0.1%
4546	1	0.1%
4501	1	0.1%
4398	1	0.1%
4392	1	0.1%
4274	1	0.1%
4236	1	0.1%
4163	1	0.1%

Date
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	940
Missing (%)	100.0%
Memory size	14.7 KiB

WeightKg
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	940
Missing (%)	100.0%
Memory size	14.7 KiB

WeightPounds
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	940
Missing (%)	100.0%
Memory size	14.7 KiB

Fat
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	940
Missing (%)	100.0%
Memory size	14.7 KiB

BMI
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	940
Missing (%)	100.0%
Memory size	14.7 KiB

IsManualReport
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	940
Missing (%)	100.0%
Memory size	14.7 KiB

LogId
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	940
Missing (%)	100.0%
Memory size	14.7 KiB

Auto

Heatmap
Table

	Id	TotalSteps	TotalDistance	TrackerDistance	LoggedActivitiesDistance	VeryActiveDistance	ModeratelyActiveDistance	LightActiveDistance	SedentaryActiveDistance	VeryActiveMinutes	FairlyActiveMinutes	LightlyActiveMinutes	SedentaryMinutes	Calories	ActivityDate
Id	1.000	0.158	0.199	0.197	0.210	0.223	0.111	0.030	-0.114	0.251	0.125	-0.084	-0.064	0.429	0.000
TotalSteps	0.158	1.000	0.992	0.992	0.180	0.770	0.704	0.715	0.015	0.749	0.689	0.581	-0.428	0.559	0.000
TotalDistance	0.199	0.992	1.000	1.000	0.203	0.776	0.701	0.715	0.013	0.752	0.685	0.559	-0.414	0.617	0.000
TrackerDistance	0.197	0.992	1.000	1.000	0.193	0.775	0.701	0.714	0.011	0.751	0.686	0.558	-0.415	0.617	0.000
LoggedActivitiesDistance	0.210	0.180	0.203	0.193	1.000	0.226	0.157	0.139	0.010	0.265	0.133	0.057	-0.087	0.226	0.000
VeryActiveDistance	0.223	0.770	0.776	0.775	0.226	1.000	0.749	0.285	-0.064	0.970	0.743	0.158	-0.235	0.497	0.000
ModeratelyActiveDistance	0.111	0.704	0.701	0.701	0.157	0.749	1.000	0.361	-0.096	0.734	0.980	0.244	-0.308	0.403	0.016
LightActiveDistance	0.030	0.715	0.715	0.714	0.139	0.285	0.361	1.000	0.142	0.285	0.345	0.878	-0.466	0.465	0.000
SedentaryActiveDistance	-0.114	0.015	0.013	0.011	0.010	-0.064	-0.096	0.142	1.000	-0.057	-0.103	0.194	0.096	0.010	0.000
VeryActiveMinutes	0.251	0.749	0.752	0.751	0.265	0.970	0.734	0.285	-0.057	1.000	0.746	0.152	-0.241	0.540	0.000
FairlyActiveMinutes	0.125	0.689	0.685	0.686	0.133	0.743	0.980	0.345	-0.103	0.746	1.000	0.232	-0.314	0.435	0.051
LightlyActiveMinutes	-0.084	0.581	0.559	0.558	0.057	0.158	0.244	0.878	0.194	0.152	0.232	1.000	-0.480	0.286	0.000
SedentaryMinutes	-0.064	-0.428	-0.414	-0.415	-0.087	-0.235	-0.308	-0.466	0.096	-0.241	-0.314	-0.480	1.000	-0.152	0.097
Calories	0.429	0.559	0.617	0.617	0.226	0.497	0.403	0.465	0.010	0.540	0.435	0.286	-0.152	1.000	0.119
ActivityDate	0.000	0.000	0.000	0.000	0.000	0.000	0.016	0.000	0.000	0.000	0.051	0.000	0.097	0.119	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Id	ActivityDate	TotalSteps	TotalDistance	TrackerDistance	VeryActiveDistance	ModeratelyActiveDistance	LightActiveDistance	VeryActiveMinutes	FairlyActiveMinutes	LightlyActiveMinutes	SedentaryMinutes	Calories	Date	WeightKg	WeightPounds	Fat	BMI	IsManualReport	LogId
0	1503960366	4/12/2016	13162	8.50	8.50	1.88	0.55	6.06	25	13	328	728	1985	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	1503960366	4/13/2016	10735	6.97	6.97	1.57	0.69	4.71	21	19	217	776	1797	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	1503960366	4/14/2016	10460	6.74	6.74	2.44	0.40	3.91	30	11	181	1218	1776	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	1503960366	4/15/2016	9762	6.28	6.28	2.14	1.26	2.83	29	34	209	726	1745	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	1503960366	4/16/2016	12669	8.16	8.16	2.71	0.41	5.04	36	10	221	773	1863	NaN	NaN	NaN	NaN	NaN	NaN	NaN
5	1503960366	4/17/2016	9705	6.48	6.48	3.19	0.78	2.51	38	20	164	539	1728	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	1503960366	4/18/2016	13019	8.59	8.59	3.25	0.64	4.71	42	16	233	1149	1921	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	1503960366	4/19/2016	15506	9.88	9.88	3.53	1.32	5.03	50	31	264	775	2035	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	1503960366	4/20/2016	10544	6.68	6.68	1.96	0.48	4.24	28	12	205	818	1786	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	1503960366	4/21/2016	9819	6.34	6.34	1.34	0.35	4.65	19	8	211	838	1775	NaN	NaN	NaN	NaN	NaN	NaN	NaN

	Id	ActivityDate	TotalSteps	TotalDistance	TrackerDistance	VeryActiveDistance	ModeratelyActiveDistance	LightActiveDistance	SedentaryActiveDistance	VeryActiveMinutes	FairlyActiveMinutes	LightlyActiveMinutes	SedentaryMinutes	Calories	Date	WeightKg	WeightPounds	Fat	BMI	IsManualReport	LogId
930	8877689391	5/3/2016	10818	8.210000	8.210000	1.39	0.10	6.67	0.01	19	3	229	1189	2817	NaN	NaN	NaN	NaN	NaN	NaN	NaN
931	8877689391	5/4/2016	18193	16.299999	16.299999	10.42	0.31	5.53	0.00	66	8	212	1154	3477	NaN	NaN	NaN	NaN	NaN	NaN	NaN
932	8877689391	5/5/2016	14055	10.670000	10.670000	5.46	0.82	4.37	0.00	67	15	188	1170	3052	NaN	NaN	NaN	NaN	NaN	NaN	NaN
933	8877689391	5/6/2016	21727	19.340000	19.340000	12.79	0.29	6.16	0.00	96	17	232	1095	4015	NaN	NaN	NaN	NaN	NaN	NaN	NaN
934	8877689391	5/7/2016	12332	8.130000	8.130000	0.08	0.96	6.99	0.00	105	28	271	1036	4142	NaN	NaN	NaN	NaN	NaN	NaN	NaN
935	8877689391	5/8/2016	10686	8.110000	8.110000	1.08	0.20	6.80	0.00	17	4	245	1174	2847	NaN	NaN	NaN	NaN	NaN	NaN	NaN
936	8877689391	5/9/2016	20226	18.250000	18.250000	11.10	0.80	6.24	0.05	73	19	217	1131	3710	NaN	NaN	NaN	NaN	NaN	NaN	NaN
937	8877689391	5/10/2016	10733	8.150000	8.150000	1.35	0.46	6.28	0.00	18	11	224	1187	2832	NaN	NaN	NaN	NaN	NaN	NaN	NaN
938	8877689391	5/11/2016	21420	19.559999	19.559999	13.22	0.41	5.89	0.00	88	12	213	1127	3832	NaN	NaN	NaN	NaN	NaN	NaN	NaN
939	8877689391	5/12/2016	8064	6.120000	6.120000	1.82	0.04	4.25	0.00	23	1	137	770	1849	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample